--USE Liberty
--GO
---------------------------------------------------------------------------------------------------
IF (SELECT OBJECT_ID('dbo.GetServiceManDetails')) IS NOT NULL
BEGIN
	DROP PROCEDURE dbo.GetServiceManDetails 
END
---------------------------------------------------------------------------------------------------

GO
CREATE PROCEDURE dbo.GetServiceManDetails
@OID		bigint

AS 

---------------------------------------------------------------------------------------------------
--						Liberty
---------------------------------------------------------------------------------------------------
--  Stored Procedure :: GetServiceManDetails
--                                                                            
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

SELECT 	OID,
		Version,
		PrimaryAddressID,
		PermanentAddressID
FROM dbo.ServiceMen
WHERE OID = @OID

GO

---------------------------------------------------------------------------------------------------
-- Assign appropriate permissions
---------------------------------------------------------------------------------------------------
GRANT EXECUTE ON DBO.GetServiceManDetails TO [Liberty_Users]
GO

